package inet.app.controller.database;

import inet.app.view.activity.MyApp;

/**
 * Database configuration
 * 
 */
public class DBConfig {
	
	private static int DB_VERSION = 1;
	private static String DB_NAME = "appxs";

	public static final String COL_ID = "id";
	
	//table kqgiai theo vung
	public static final String TABLE_KQGIAI_REGION = "kqgiai_region";
	public static final String COL_KQGIAI_REGION_REGION = "region";
	public static final String COL_KQGIAI_REGION_DATE = "date";

	// table kqgiai xo so
	public static final String TABLE_KQGIAI_XS = "kqgiaixoso";
	public static final String COL_KQGIAI_XS_CODE = "code";
	public static final String COL_KQGIAI_XS_NAME = "name";
	public static final String COL_KQGIAI_XS_DATE = "date";
	public static final String COL_KQGIAI_XS_REGIONID = "region_id";
	public static final String COL_KQGIAI_XS_GIAIDB = "giaidb";
	public static final String COL_KQGIAI_XS_GIAI1 = "giai1";
	public static final String COL_KQGIAI_XS_GIAI2 = "giai2";
	public static final String COL_KQGIAI_XS_GIAI3 = "giai3";
	public static final String COL_KQGIAI_XS_GIAI4 = "giai4";
	public static final String COL_KQGIAI_XS_GIAI5 = "giai5";
	public static final String COL_KQGIAI_XS_GIAI6 = "giai6";
	public static final String COL_KQGIAI_XS_GIAI7 = "giai7";
	public static final String COL_KQGIAI_XS_GIAI8 = "giai8";
	
	//table kqgiai xoso dien toan
	public static final String TABLE_KQGIAI_XSDT = "kqgiaixosodt";
	public static final String COL_KQGIAI_XSDT_DATE = "date";
	public static final String COL_KQGIAI_XSDT_DT123 = "dt123";
	public static final String COL_KQGIAI_XSDT_DT6x36 = "dt6x36";
	public static final String COL_KQGIAI_XSDT_TT = "tt";
	
	//table so mo
	public static final String TABLE_SOMO = "somo";
	public static final String COL_SOMO_NAME = "name";
	public static final String COL_SOMO_NAMEVN = "namevn";
	public static final String COL_SOMO_NUMBERS = "numbers";
	
	//table thongke nhanh
	public static final String TABLE_TK_NHANH = "tknhanh";
	public static final String COL_TK_NHANH_CODE = "code";
	public static final String COL_TK_NHANH_NAME = "name";
	public static final String COL_TK_NHANH_NUMBERDATE = "numberdate";
	public static final String COL_TK_NHANH_NUMBERCOUPLE = "numbercouple";
	public static final String COL_TK_NHANH_TKCS = "tkcs";
	public static final String COL_TK_NHANH_MOST = "most";
	public static final String COL_TK_NHANH_LEAST = "least";
	
	public static final String COL_TK_NHANH_NUMBER = "number";
	public static final String COL_TK_NHANH_DATE = "date";
	public static final String COL_TK_NHANH_CHUARA = "chuara";
	public static final String COL_TK_NHANH_CUCDAI = "cucdai";
	
	//table tinh soi cau
	public static final String TABLE_TINH_SC = "tinh_sc";
	public static final String COL_TINH_SC_CODE = "code";
	public static final String COL_TINH_SC_NAME = "name";
	
	public static String getDatabaseName() {
		return DB_NAME;
	}

	public static String getDBPath() {
		return "/data/data/" + MyApp.class.getPackage().getName()
				+ "/databases/";
	}

	public static String getDBFullPath() {
		return getDBPath() + DB_NAME;
	}

	public static int getVersion() {
		return DB_VERSION;
	}

	public static int getDBVersion() {
		return DB_VERSION;
	}
}
